<%@ page import="java.sql.*,studentportal.*"%>
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>

<body background="indtextb.jpg" bgcolor="#FFFFFF" text="#000000" link="#3366CC" vlink="#666666" alink="#996600">

<table border="0" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="100%"><img border="0" src="StdPrtlbanner.jpg" width="846" height="65">&nbsp;</td>
  </tr>
</table>
<table border="0" width="100%">
  <tr>
     <td width="20%">
      <p align="center"><font face="Trebuchet MS, Arial, Helvetica">
      <a href="FacultyPersonalInfoView.jsp"><b>Personal Info</b></a></font></td>

     <td width="20%">
      <p align="center"><font face="Trebuchet MS, Arial, Helvetica">
      <a href="FacultyListCourses.jsp"><b>View Courses</b></a></font></td>
   
    <td width="20%">
      <p align="center"><a href="Home.html"><b>Home</b></a></td>
  </tr>
</table>


<!--mstheme--><font face="Trebuchet MS, Arial, Helvetica"><!--mstheme--></font>
<%
					Connection con=MySQLDriver.getConnection(); 
					Statement st=con.createStatement();
					System.out.println("After Statemfgjgfjghjent");
					String ssss="select faculty_id, faculty_name, faculty_address, faculty_dob, faculty_phone, faculty_email, faculty_join_date, (select branch_name from branch_master where faculty_master.faculty_dept_id=branch_master.branch_id), (select desigantion_name from designation_master where faculty_master.faculty_designation_id=designation_master.designation_id), faculty_login_name, faculty_lstatus from faculty_master where faculty_id='"+session.getAttribute("FacultyID")+"'";
					System.out.println(ssss);
					ResultSet rs=st.executeQuery(ssss);
					if(rs.next()) {

%>
<p align="center">&nbsp;</p>
<form method="POST" action="./FacultyRegServlet">
  <!--webbot bot="SaveResults"
  U-File="E:\StudentPortal\_private\form_results.txt" S-Format="TEXT/CSV"
  S-Label-Fields="TRUE" -->
  <div align="center">
    <center>
    <table border="1" width="68%" bordercolor="#0000FF">
      <tr>
        <td width="100%" colspan="2">
          <p align="center">Personal Information</td>
      </tr>
    </center>
    <tr>
      <td width="50%" valign="middle" align="left">
        <p align="left">Faculty ID</td>
      <center>
      <td width="50%"><input type="text" name="fid" size="20" tabindex="1" value="<%=rs.getString(1)%>"></td>
      </tr>
    </center>
    <tr>
      <td width="50%" valign="middle" align="left">
        <p align="left">Name</td>
      <center>
      <td width="50%"><input type="text" name="fname" size="20" tabindex="2" value="<%=rs.getString(2)%>"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="left">Address</td>
        <td width="50%"><textarea rows="2" name="fadd" cols="20" tabindex="3"><%=rs.getString(3)%></textarea></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="left">Date of Birth</td>
        <td width="50%"><input type="text" name="fdob" size="20" tabindex="4" value="<%=rs.getDate(4)%>"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="left">Phone Number</td>
        <td width="50%"><input type="text" name="fphone" size="20" tabindex="5" value="<%=rs.getString(5)%>"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="left">Email ID</td>
        <td width="50%"><input type="text" name="femail" size="20" tabindex="6" value="<%=rs.getString(6)%>"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="left">Date of Join</td>
        <td width="50%"><input type="text" name="fdoa" size="20" tabindex="7" value="<%=rs.getDate(7)%>"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="left">Department Name</td>
        <td width="50%"><input type="text" name="fdept" size="20" tabindex="8" value="<%=rs.getString(8)%>"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="left">Designation Name</td>
        <td width="50%"><input type="text" name="fdeg" size="20" tabindex="9" value="<%=rs.getString(9)%>"></td>

      </tr>
      <tr>
        <td width="50%" valign="middle" align="left">Login Name</td>
        <td width="50%"><input type="text" name="flogin" size="20" tabindex="10" value="<%=rs.getString(10)%>"></td>
      </tr>
   </table>
    </center>
  </div>
  <%
  		}con.close();
  %>
</form>
<p align="left">&nbsp;</p>


</body>

</html>
